package com.cs.beneficios.web.action;

import com.cs.beneficios.business.entity.VerificacionDAO;
import com.cs.beneficios.common.ConnectionFactory;
import com.cs.paoyer.administration.business.model.UserVO;

import java.io.IOException;

import java.sql.SQLException;

import java.util.Collection;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;


public class IngresoArchivoVerificacionAction extends Action {
    /**This is the main action called from the Struts framework.
     * @param mapping The ActionMapping used to select this instance.
     * @param form The optional ActionForm bean for this request.
     * @param request The HTTP Request we are processing.
     * @param response The HTTP Response we are processing.
     */
    public ActionForward execute(ActionMapping mapping, ActionForm form, 
                                 HttpServletRequest request, 
                                 HttpServletResponse response) throws IOException, 
                                                                      ServletException {
        
        ConnectionFactory cf = new ConnectionFactory();
        HttpSession session = request.getSession();
        UserVO user = (UserVO) session.getAttribute("userInfo");
        VerificacionDAO verificacionDAO = new VerificacionDAO(cf);
         
         Collection verificados = null;
         try{
             verificados = verificacionDAO.getVerification(user.getName());
             cf.closeConnection(verificacionDAO.getConn());
             if(verificados.size() > 0){
                 request.setAttribute("verificados", verificados);
             }
         } catch(SQLException e){
			System.err.println("/******** TDSUB - cwsub");
			e.printStackTrace();
			System.err.println("TDSSPE - cwsub ********/");
             request.setAttribute("msg", "Ocurrio un error en la generación del reporte.");
             return mapping.findForward("success");
         }

        return mapping.findForward( "success");
    }
}

